package com.example.springboot_project.mapper;

import org.apache.ibatis.annotations.Param;

import java.util.List;

import com.example.springboot_project.entity.Students;
import org.apache.ibatis.annotations.Mapper;

/**
 * @author 86182
 * @description 针对表【students】的数据库操作Mapper
 * @createDate 2022-09-14 15:52:27
 * @Entity com.example.springboot_project.entity.Students
 */
@Mapper
public interface StudentsMapper {

    int deleteByPrimaryKey(Integer id);

    int insert(Students record);

    int insertSelective(Students record);

    Students selectByPrimaryKey(Long id);

    int updateByPrimaryKeySelective(Students record);

    int updateByPrimaryKey(Students record);

    List<Students> findAll();

    //使用手机号和密码验证登录
    Students selectByStuPhoneAndStuPwdAndStuName(@Param("stuPhone") String stuPhone, @Param("stuPwd") String stuPwd, @Param("stuName") String stuName);
}
